1.主PY文件写视图函数,带id参数。
@app.route('/detail/')def detail(question_id): quest=Question.query.filter(Question.id==question_id).first() return render_template('detail.html', ques=quest)
2.首页标题的标签做带参数的链接。
{ { url_for('detail',question_id = foo.id) }}
详情:{
{ foo.detail }} { { foo.creat_time }}
3.在详情页将数据的显示在恰当的位置。
{ { ques.title}} { { ques.id }}{ { ques.creat_time }}
{ { ques.author.username }} { { ques.detail }}
{% extends 'base2.html' %}{% block title %}问答详情{% endblock %}{% block main %}详情页
{ { ques.title }}{ { ques.author.username }}{ { ques.creat_time }}
{
{ ques.detail }}
4.建立评论的对象关系映射:
class Comment(db.Model):
__tablename__='comment'5.尝试实现发布评论。
class Comment(db.Model): __tablename__ = 'comment' id = db.Column(db.Integer, primary_key=True, autoincrement=True) author_id = db.Column(db.Integer, db.ForeignKey('user.id')) question_id = db.Column(db.Integer, db.ForeignKey('question.id')) detail = db.Column(db.Text, nullable=False) create_time = db.Column(db.DateTime, default=datetime.now) question = db.relationship('Question', backref=db.backref('comments',order_by=create_time.desc)) author = db.relationship('User', backref=db.backref('comments'))